package com.zzgc.modules.param;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.util.Date;

/**
 * 导出和页面展示的学生信息模板类
 * @Author:
 * @CreateTime: 2022-11-23  15:38
 * @Description:
 * @Version: 1.0
 */
@Data
@EqualsAndHashCode(callSuper = false)
public class ExportStudentTemplate {
    @ExcelProperty("学号")
    @ColumnWidth(15)
//    @ContentStyle(dataFormat = 2)
    private String sStudentNum;
    @ExcelProperty("姓名")
    @ColumnWidth(10)
    private String sName;
    @ExcelProperty("性别")
    @ColumnWidth(10)
    private String sSex;
    @ExcelProperty("出生日期")
    @ColumnWidth(20)
    @DateTimeFormat("yyyy-MM-dd")
    private Date sBirthday;
    @ExcelProperty("手机号")
    @ColumnWidth(15)
    private String sMobile;
    @ExcelProperty("身份证号")
    @ColumnWidth(25)
    private String sIdCard;
    @ExcelProperty("学校")
    @ColumnWidth(20)
    private String sSchoolName;
    @ExcelProperty("学年")
    @ColumnWidth(10)
    private String sYear;
    @ExcelProperty("年级")
    @ColumnWidth(10)
    private String sGradeName;
    @ExcelProperty("班级")
    @ColumnWidth(10)
    private String sClassName;
    @ExcelProperty("创建时间")
    @ColumnWidth(25)
    @DateTimeFormat("yyyy-MM-dd")
    private Date sCreateDate;
}
